IF NOT EXISTS
(
	SELECT * FROM dbo.[ExampleTable] WHERE [ColumnName]=value
)
	BEGIN
	SET IDENTITY_INSERT dbo.[ExampleTable] ON
	INSERT INTO dbo.[ExampleTable] ([Id], [NameId]) VALUES (1, value)
	SET IDENTITY_INSERT dbo.[ExampleTable] OFF
	END
GO